package office.dao.person;

import platform.common.dao.impl.BaseDomainProviderImpl;

public class TableDP extends BaseDomainProviderImpl  {
	
	public String getTableByUserAndDate(){
		String hql = "from Table where user.id = ? and outDate in (?) order by outDate desc";
		return hql;
	}
	
	public String getAllTableByUser(){
		String hql = "from Table where user.id = ? order by outDate desc";
		return hql;
	}
	
	public String getAllTableByUserAndDate(){
		String hql = "from Table where user.id = ? and outDate >= ? and  outDate <= ? order by outDate desc";
		return hql;
	}
	
	public String getAllTableByDate(){
		String hql = "from Table where outDate >= ? and outDate <= ? order by outDate desc";
		return hql;
	}

}
